package com.example.nonacademic_education.dao;

import com.example.nonacademic_education.entity.SqlBackups;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SqlBackupsDao {
    @Select("select * from sql_backups limit #{page},#{size}")
    List<SqlBackups> getList(Integer page, Integer size);

    @Select("select count(id) from sql_backups")
    Integer count();

    @Insert("insert into sql_backups(id, filename, file_url) VALUE (null,#{filename},#{s})")
    Integer addOne(String filename, String s);
}
